CREATE TABLE [dbo].[T_DOCTOR]
(
[DOCTOR_ID] [bigint] NOT NULL IDENTITY(1, 1),
[PERSON_ID] [bigint] NULL,
[DOCTOR_STATUS] [bit] NOT NULL,
[CREATE_DATE] [datetime] NOT NULL,
[DISABLE_DATE] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_DOCTOR] ADD CONSTRAINT [PK__T_DOCTOR__596ABDB0D689C22B] PRIMARY KEY CLUSTERED  ([DOCTOR_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_DOCTOR] ADD CONSTRAINT [FK__T_DOCTOR__PERSON__245D67DE] FOREIGN KEY ([PERSON_ID]) REFERENCES [dbo].[T_PERSON] ([PERSON_ID])
GO
